package com.yxp423.ssmempl.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yxp423.ssmempl.bean.EmplLog;
import com.yxp423.ssmempl.bean.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description: java类作用描述
 * @Author: yxp
 * @CreateDate: 2019-05-24 21:10
 * @Version: 1.0
 */
@Mapper
public interface EmplLogMapper extends BaseMapper<EmplLog> {

	@Select("SELECT * FROM empl_log WHERE user_id=#{userId} AND DATE_FORMAT(log_time,'%Y%M')=DATE_FORMAT(CURDATE(),'%Y%M')")
	List<EmplLog> selectMyEmplLog(User user);

}
